Tabela UserType

Definicja tabeli UserType

Name

UserType

Code

UserType

Comment

PL: Definicja typów uzytkowników
EN: User type's definition


Lista kolumn tabeli UserType

Name

Code

UserTypeID

UserTypeID

Code

Code

ShortName

ShortName

FullName

FullName

Description

Description

Active

Active


Kolumna UserTypeID tabeli UserType

Definicja kolumny UserTypeID tabeli UserType

Name

UserTypeID

Code

UserTypeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna Code tabeli UserType

Definicja kolumny Code tabeli UserType

Name

Code

Code

Code

Data Type

VARCHAR2(22)

Mandatory

No

Comment

PL: Kod wiersza
EN: Record's code
DE: Der code des Rekord


Kolumna ShortName tabeli UserType

Definicja kolumny ShortName tabeli UserType

Name

ShortName

Code

ShortName

Data Type

VARCHAR2(32)

Mandatory

No

Comment

PL: Skrócona nazwa wiersza
EN: Record's short name
DE: Der kurz Name des Rekord


Kolumna FullName tabeli UserType

Definicja kolumny FullName tabeli UserType

Name

FullName

Code

FullName

Data Type

VARCHAR2(255)

Mandatory

No

Comment

PL: Pelna nazwa wiersza
EN: Record's full name
DE: Der voll Name des Rekord


Kolumna Description tabeli UserType

Definicja kolumny Description tabeli UserType

Name

Description

Code

Description

Data Type

VARCHAR2(48)

Mandatory

No

Comment

PL: Opis wiersza
EN: Record's description
DE: Die Beschreibung des Rekord


Kolumna Active tabeli UserType

Definicja kolumny Active tabeli UserType

Name

Active

Code

Active

Data Type

NUMBER(5)

Mandatory

No

Comment

PL: Aktywnosc wiersza.
EN: Record's Activity
DE: Aktivitat des Rekord


Lista kluczy tabeli UserType

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli UserType

Definicja klucza Identifier_1 tabeli UserType

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment